package com.site.dao;

import com.site.pojo.ReserveType;
import com.site.vo.ReserveTypeAndGoodsVO;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

/**
 * FileName: ReserveTypeDao.java
 * 仓库分类表Dao
 *
 * @author 田尚忠
 * @Date    2021/11/28
 * @version 1.00
 */
public interface ReserveTypeDao {
    /*查询方法*/
        //查询全部
        List<ReserveType> selectAll() throws SQLException;

        //通过id查询
        ReserveType selectById(int id) throws SQLException;
    /*增加方法*/
        int addReserveType(ReserveType reserveType);
        int addReserveType(Connection conn,ReserveType reserveType);
    /*删除方法*/
        //通过id删除
        int delReserveTypeById(int id);
        int delReserveTypeById(Connection conn,int id);

        //通过状态进行删除
        int delReserveTypeByState(int state);
        int delReserveTypeByState(Connection conn,int state);
    /*修改方法*/
        //通过id进行修改
        int updateReserveTypeByid(int id,ReserveType reserveType);
        int updateReserveTypeByid(Connection conn,int id,ReserveType reserveType);


        //仓库所有信息
        List<ReserveTypeAndGoodsVO> allVOCableSize() throws SQLException;
        List<ReserveTypeAndGoodsVO> allVOCircuitBoardSize() throws SQLException;
        List<ReserveTypeAndGoodsVO> allVOElectricWireSize() throws SQLException;
}
